Dataset statistics
| Number of variables | 53 |
|---|---|
| Number of observations | 39717 |
| Missing cells | 4516 |
| Missing cells (%) | 0.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 16.1 MiB |
| Average record size in memory | 424.0 B |
Variable types
| NUM | 24 |
|---|---|
| CAT | 22 |
| BOOL | 6 |
| URL | 1 |
Reproduction
| Analysis started | 2020-08-28 06:00:06.651847 |
|---|---|
| Analysis finished | 2020-08-28 06:01:31.180300 |
| Duration | 1 minute and 24.53 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
pymnt_plan has constant value "n" | Constant |
initial_list_status has constant value "f" | Constant |
policy_code has constant value "1" | Constant |
application_type has constant value "INDIVIDUAL" | Constant |
acc_now_delinq has constant value "0" | Constant |
delinq_amnt has constant value "0" | Constant |
int_rate has a high cardinality: 371 distinct values | High cardinality |
emp_title has a high cardinality: 28820 distinct values | High cardinality |
issue_d has a high cardinality: 55 distinct values | High cardinality |
title has a high cardinality: 19615 distinct values | High cardinality |
zip_code has a high cardinality: 823 distinct values | High cardinality |
earliest_cr_line has a high cardinality: 526 distinct values | High cardinality |
revol_util has a high cardinality: 1089 distinct values | High cardinality |
last_pymnt_d has a high cardinality: 101 distinct values | High cardinality |
last_credit_pull_d has a high cardinality: 106 distinct values | High cardinality |
member_id is highly correlated with id | High correlation |
id is highly correlated with member_id | High correlation |
funded_amnt is highly correlated with loan_amnt and 3 other fields | High correlation |
loan_amnt is highly correlated with funded_amnt and 2 other fields | High correlation |
funded_amnt_inv is highly correlated with loan_amnt and 3 other fields | High correlation |
installment is highly correlated with loan_amnt and 2 other fields | High correlation |
out_prncp_inv is highly correlated with out_prncp | High correlation |
out_prncp is highly correlated with out_prncp_inv | High correlation |
total_pymnt is highly correlated with funded_amnt and 2 other fields | High correlation |
total_pymnt_inv is highly correlated with funded_amnt_inv and 2 other fields | High correlation |
total_rec_prncp is highly correlated with total_pymnt and 1 other fields | High correlation |
sub_grade is highly correlated with grade | High correlation |
grade is highly correlated with sub_grade | High correlation |
emp_title has 2459 (6.2%) missing values | Missing |
emp_length has 1075 (2.7%) missing values | Missing |
pub_rec_bankruptcies has 697 (1.8%) missing values | Missing |
annual_inc is highly skewed (γ1 = 30.9491846) | Skewed |
collection_recovery_fee is highly skewed (γ1 = 25.02941842) | Skewed |
id has unique values | Unique |
member_id has unique values | Unique |
url has unique values | Unique |
delinq_2yrs has 35405 (89.1%) zeros | Zeros |
inq_last_6mths has 19300 (48.6%) zeros | Zeros |
pub_rec has 37601 (94.7%) zeros | Zeros |
revol_bal has 994 (2.5%) zeros | Zeros |
out_prncp has 38577 (97.1%) zeros | Zeros |
out_prncp_inv has 38577 (97.1%) zeros | Zeros |
total_rec_late_fee has 37671 (94.8%) zeros | Zeros |
recoveries has 35499 (89.4%) zeros | Zeros |
collection_recovery_fee has 35935 (90.5%) zeros | Zeros |
| Distinct count | 39717 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 683131.9130598988 |
|---|---|
| Minimum | 54734 |
| Maximum | 1077501 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 54734 |
|---|---|
| 5-th percentile | 372418.4 |
| Q1 | 516221 |
| median | 665665 |
| Q3 | 837755 |
| 95-th percentile | 1039966.2 |
| Maximum | 1077501 |
| Range | 1022767 |
| Interquartile range (IQR) | 321534 |
Descriptive statistics
| Standard deviation | 210694.1329 |
|---|---|
| Coefficient of variation (CV) | 0.3084237889 |
| Kurtosis | -0.7298893992 |
| Mean | 683131.9131 |
| Median Absolute Deviation (MAD) | 160026 |
| Skewness | 0.07880763188 |
| Sum | 2.713195019e+10 |
| Variance | 4.439201764e+10 |
| Value | Count | Frequency (%) | |
| 1052670 | 1 | < 0.1% | |
| 685540 | 1 | < 0.1% | |
| 253425 | 1 | < 0.1% | |
| 730606 | 1 | < 0.1% | |
| 867821 | 1 | < 0.1% | |
| 986603 | 1 | < 0.1% | |
| 444881 | 1 | < 0.1% | |
| 649578 | 1 | < 0.1% | |
| 878054 | 1 | < 0.1% | |
| 264792 | 1 | < 0.1% | |
| Other values (39707) | 39707 | > 99.9% |
| Value | Count | Frequency (%) | |
| 54734 | 1 | < 0.1% | |
| 55742 | 1 | < 0.1% | |
| 57245 | 1 | < 0.1% | |
| 57416 | 1 | < 0.1% | |
| 58915 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1077501 | 1 | < 0.1% | |
| 1077430 | 1 | < 0.1% | |
| 1077175 | 1 | < 0.1% | |
| 1076863 | 1 | < 0.1% | |
| 1075358 | 1 | < 0.1% |
| Distinct count | 39717 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 850463.5594078102 |
|---|---|
| Minimum | 70699 |
| Maximum | 1314167 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 70699 |
|---|---|
| 5-th percentile | 388192.4 |
| Q1 | 666780 |
| median | 850812 |
| Q3 | 1047339 |
| 95-th percentile | 1269461.8 |
| Maximum | 1314167 |
| Range | 1243468 |
| Interquartile range (IQR) | 380559 |
Descriptive statistics
| Standard deviation | 265678.3074 |
|---|---|
| Coefficient of variation (CV) | 0.3123923471 |
| Kurtosis | -0.5629680132 |
| Mean | 850463.5594 |
| Median Absolute Deviation (MAD) | 190427 |
| Skewness | -0.2124163719 |
| Sum | 3.377786119e+10 |
| Variance | 7.058496303e+10 |
| Value | Count | Frequency (%) | |
| 745584 | 1 | < 0.1% | |
| 900541 | 1 | < 0.1% | |
| 634745 | 1 | < 0.1% | |
| 943558 | 1 | < 0.1% | |
| 896958 | 1 | < 0.1% | |
| 740803 | 1 | < 0.1% | |
| 941505 | 1 | < 0.1% | |
| 720462 | 1 | < 0.1% | |
| 959934 | 1 | < 0.1% | |
| 499901 | 1 | < 0.1% | |
| Other values (39707) | 39707 | > 99.9% |
| Value | Count | Frequency (%) | |
| 70699 | 1 | < 0.1% | |
| 73673 | 1 | < 0.1% | |
| 74724 | 1 | < 0.1% | |
| 76583 | 1 | < 0.1% | |
| 80353 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1314167 | 1 | < 0.1% | |
| 1313524 | 1 | < 0.1% | |
| 1311748 | 1 | < 0.1% | |
| 1311441 | 1 | < 0.1% | |
| 1306957 | 1 | < 0.1% |
| Distinct count | 885 |
|---|---|
| Unique (%) | 2.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11219.443814991062 |
|---|---|
| Minimum | 500 |
| Maximum | 35000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 500 |
|---|---|
| 5-th percentile | 2400 |
| Q1 | 5500 |
| median | 10000 |
| Q3 | 15000 |
| 95-th percentile | 25000 |
| Maximum | 35000 |
| Range | 34500 |
| Interquartile range (IQR) | 9500 |
Descriptive statistics
| Standard deviation | 7456.670694 |
|---|---|
| Coefficient of variation (CV) | 0.6646203517 |
| Kurtosis | 0.7686685518 |
| Mean | 11219.44381 |
| Median Absolute Deviation (MAD) | 5000 |
| Skewness | 1.05931729 |
| Sum | 445602650 |
| Variance | 55601937.84 |
| Value | Count | Frequency (%) | |
| 10000 | 2833 | 7.1% | |
| 12000 | 2334 | 5.9% | |
| 5000 | 2051 | 5.2% | |
| 6000 | 1908 | 4.8% | |
| 15000 | 1895 | 4.8% | |
| 20000 | 1626 | 4.1% | |
| 8000 | 1586 | 4.0% | |
| 25000 | 1390 | 3.5% | |
| 4000 | 1130 | 2.8% | |
| 3000 | 1030 | 2.6% | |
| Other values (875) | 21934 | 55.2% |
| Value | Count | Frequency (%) | |
| 500 | 5 | < 0.1% | |
| 700 | 1 | < 0.1% | |
| 725 | 1 | < 0.1% | |
| 750 | 1 | < 0.1% | |
| 800 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 35000 | 679 | 1.7% | |
| 34800 | 2 | < 0.1% | |
| 34675 | 1 | < 0.1% | |
| 34525 | 1 | < 0.1% | |
| 34475 | 5 | < 0.1% |
| Distinct count | 1041 |
|---|---|
| Unique (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10947.713195860715 |
|---|---|
| Minimum | 500 |
| Maximum | 35000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 500 |
|---|---|
| 5-th percentile | 2400 |
| Q1 | 5400 |
| median | 9600 |
| Q3 | 15000 |
| 95-th percentile | 25000 |
| Maximum | 35000 |
| Range | 34500 |
| Interquartile range (IQR) | 9600 |
Descriptive statistics
| Standard deviation | 7187.23867 |
|---|---|
| Coefficient of variation (CV) | 0.6565059334 |
| Kurtosis | 0.9375519943 |
| Mean | 10947.7132 |
| Median Absolute Deviation (MAD) | 4600 |
| Skewness | 1.081710238 |
| Sum | 434810325 |
| Variance | 51656399.7 |
| Value | Count | Frequency (%) | |
| 10000 | 2741 | 6.9% | |
| 12000 | 2244 | 5.6% | |
| 5000 | 2040 | 5.1% | |
| 6000 | 1898 | 4.8% | |
| 15000 | 1784 | 4.5% | |
| 8000 | 1573 | 4.0% | |
| 20000 | 1456 | 3.7% | |
| 25000 | 1133 | 2.9% | |
| 4000 | 1127 | 2.8% | |
| 3000 | 1022 | 2.6% | |
| Other values (1031) | 22699 | 57.2% |
| Value | Count | Frequency (%) | |
| 500 | 5 | < 0.1% | |
| 700 | 1 | < 0.1% | |
| 725 | 1 | < 0.1% | |
| 750 | 1 | < 0.1% | |
| 800 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 35000 | 554 | 1.4% | |
| 34800 | 1 | < 0.1% | |
| 34675 | 2 | < 0.1% | |
| 34525 | 1 | < 0.1% | |
| 34475 | 4 | < 0.1% |
| Distinct count | 8205 |
|---|---|
| Unique (%) | 20.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10397.448867750922 |
|---|---|
| Minimum | 0.0 |
| Maximum | 35000.0 |
| Zeros | 129 |
| Zeros (%) | 0.3% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1873.658 |
| Q1 | 5000 |
| median | 8975 |
| Q3 | 14400 |
| 95-th percentile | 24736.57226 |
| Maximum | 35000 |
| Range | 35000 |
| Interquartile range (IQR) | 9400 |
Descriptive statistics
| Standard deviation | 7128.450439 |
|---|---|
| Coefficient of variation (CV) | 0.6855961044 |
| Kurtosis | 1.062544362 |
| Mean | 10397.44887 |
| Median Absolute Deviation (MAD) | 4200 |
| Skewness | 1.106212938 |
| Sum | 412955476.7 |
| Variance | 50814805.66 |
| Value | Count | Frequency (%) | |
| 5000 | 1309 | 3.3% | |
| 10000 | 1275 | 3.2% | |
| 6000 | 1200 | 3.0% | |
| 12000 | 1069 | 2.7% | |
| 8000 | 900 | 2.3% | |
| 4000 | 812 | 2.0% | |
| 3000 | 803 | 2.0% | |
| 15000 | 657 | 1.7% | |
| 7000 | 600 | 1.5% | |
| 2000 | 452 | 1.1% | |
| Other values (8195) | 30640 | 77.1% |
| Value | Count | Frequency (%) | |
| 0 | 129 | 0.3% | |
| 0.000121098 | 1 | < 0.1% | |
| 0.000531133 | 1 | < 0.1% | |
| 0.000654607 | 1 | < 0.1% | |
| 0.001867696 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 35000 | 135 | 0.3% | |
| 34997.35245 | 1 | < 0.1% | |
| 34993.65539 | 1 | < 0.1% | |
| 34993.32571 | 1 | < 0.1% | |
| 34993.26306 | 1 | < 0.1% |
term
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| 36 months | |
|---|---|
| 60 months |
| Value | Count | Frequency (%) | |
| 36 months | 29096 | 73.3% | |
| 60 months | 10621 | 26.7% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct count | 371 |
|---|---|
| Unique (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| 10.99% | 956 |
|---|---|
| 13.49% | 826 |
| 11.49% | 825 |
| 7.51% | 787 |
| 7.88% | 725 |
| Other values (366) |
| Value | Count | Frequency (%) | |
| 10.99% | 956 | 2.4% | |
| 13.49% | 826 | 2.1% | |
| 11.49% | 825 | 2.1% | |
| 7.51% | 787 | 2.0% | |
| 7.88% | 725 | 1.8% | |
| 7.49% | 656 | 1.7% | |
| 11.71% | 607 | 1.5% | |
| 9.99% | 603 | 1.5% | |
| 7.90% | 582 | 1.5% | |
| 5.42% | 573 | 1.4% | |
| Other values (361) | 32577 | 82.0% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.694287081 |
| Min length | 5 |
| Distinct count | 15383 |
|---|---|
| Unique (%) | 38.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 324.5619220988493 |
|---|---|
| Minimum | 15.69 |
| Maximum | 1305.19 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 15.69 |
|---|---|
| 5-th percentile | 71.246 |
| Q1 | 167.02 |
| median | 280.22 |
| Q3 | 430.78 |
| 95-th percentile | 762.996 |
| Maximum | 1305.19 |
| Range | 1289.5 |
| Interquartile range (IQR) | 263.76 |
Descriptive statistics
| Standard deviation | 208.8748735 |
|---|---|
| Coefficient of variation (CV) | 0.6435593929 |
| Kurtosis | 1.246801303 |
| Mean | 324.5619221 |
| Median Absolute Deviation (MAD) | 123.2 |
| Skewness | 1.128419095 |
| Sum | 12890625.86 |
| Variance | 43628.71279 |
| Value | Count | Frequency (%) | |
| 311.11 | 68 | 0.2% | |
| 180.96 | 59 | 0.1% | |
| 311.02 | 54 | 0.1% | |
| 150.8 | 48 | 0.1% | |
| 368.45 | 46 | 0.1% | |
| 372.12 | 45 | 0.1% | |
| 330.76 | 43 | 0.1% | |
| 339.31 | 42 | 0.1% | |
| 301.6 | 41 | 0.1% | |
| 186.61 | 41 | 0.1% | |
| Other values (15373) | 39230 | 98.8% |
| Value | Count | Frequency (%) | |
| 15.69 | 1 | < 0.1% | |
| 16.08 | 1 | < 0.1% | |
| 16.25 | 1 | < 0.1% | |
| 16.31 | 1 | < 0.1% | |
| 16.47 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1305.19 | 1 | < 0.1% | |
| 1302.69 | 1 | < 0.1% | |
| 1295.21 | 1 | < 0.1% | |
| 1288.1 | 2 | < 0.1% | |
| 1283.5 | 1 | < 0.1% |
| Distinct count | 7 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| B | |
|---|---|
| A | |
| C | |
| D | |
| E | |
| Other values (2) | 1365 |
| Value | Count | Frequency (%) | |
| B | 12020 | 30.3% | |
| A | 10085 | 25.4% | |
| C | 8098 | 20.4% | |
| D | 5307 | 13.4% | |
| E | 2842 | 7.2% | |
| F | 1049 | 2.6% | |
| G | 316 | 0.8% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 35 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| B3 | 2917 |
|---|---|
| A4 | 2886 |
| A5 | 2742 |
| B5 | 2704 |
| B4 | 2512 |
| Other values (30) |
| Value | Count | Frequency (%) | |
| B3 | 2917 | 7.3% | |
| A4 | 2886 | 7.3% | |
| A5 | 2742 | 6.9% | |
| B5 | 2704 | 6.8% | |
| B4 | 2512 | 6.3% | |
| C1 | 2136 | 5.4% | |
| B2 | 2057 | 5.2% | |
| C2 | 2011 | 5.1% | |
| B1 | 1830 | 4.6% | |
| A3 | 1810 | 4.6% | |
| Other values (25) | 16112 | 40.6% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
| Distinct count | 28820 |
|---|---|
| Unique (%) | 77.4% |
| Missing | 2459 |
| Missing (%) | 6.2% |
| Memory size | 310.3 KiB |
| US Army | 134 |
|---|---|
| Bank of America | 109 |
| IBM | 66 |
| AT&T | 59 |
| Kaiser Permanente | 56 |
| Other values (28815) |
| Value | Count | Frequency (%) | |
| US Army | 134 | 0.3% | |
| Bank of America | 109 | 0.3% | |
| IBM | 66 | 0.2% | |
| AT&T | 59 | 0.1% | |
| Kaiser Permanente | 56 | 0.1% | |
| USAF | 54 | 0.1% | |
| Wells Fargo | 54 | 0.1% | |
| UPS | 53 | 0.1% | |
| US Air Force | 52 | 0.1% | |
| Walmart | 45 | 0.1% | |
| Other values (28810) | 36576 | 92.1% | |
| (Missing) | 2459 | 6.2% |
Length
| Max length | 78 |
|---|---|
| Median length | 17 |
| Mean length | 17.42757509 |
| Min length | 2 |
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 1075 |
| Missing (%) | 2.7% |
| Memory size | 310.3 KiB |
| 10+ years | |
|---|---|
| < 1 year | |
| 2 years | |
| 3 years | |
| 4 years | |
| Other values (6) |
| Value | Count | Frequency (%) | |
| 10+ years | 8879 | 22.4% | |
| < 1 year | 4583 | 11.5% | |
| 2 years | 4388 | 11.0% | |
| 3 years | 4095 | 10.3% | |
| 4 years | 3436 | 8.7% | |
| 5 years | 3282 | 8.3% | |
| 1 year | 3240 | 8.2% | |
| 6 years | 2229 | 5.6% | |
| 7 years | 1773 | 4.5% | |
| 8 years | 1479 | 3.7% |
Length
| Max length | 9 |
|---|---|
| Median length | 7 |
| Mean length | 7.372661581 |
| Min length | 3 |
home_ownership
Categorical
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| RENT | |
|---|---|
| MORTGAGE | |
| OWN | 3058 |
| OTHER | 98 |
| NONE | 3 |
| Value | Count | Frequency (%) | |
| RENT | 18899 | 47.6% | |
| MORTGAGE | 17659 | 44.5% | |
| OWN | 3058 | 7.7% | |
| OTHER | 98 | 0.2% | |
| NONE | 3 | < 0.1% |
Length
| Max length | 8 |
|---|---|
| Median length | 4 |
| Mean length | 5.703955485 |
| Min length | 3 |
| Distinct count | 5318 |
|---|---|
| Unique (%) | 13.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 68968.92637711811 |
|---|---|
| Minimum | 4000.0 |
| Maximum | 6000000.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 4000 |
|---|---|
| 5-th percentile | 24000 |
| Q1 | 40404 |
| median | 59000 |
| Q3 | 82300 |
| 95-th percentile | 142000 |
| Maximum | 6000000 |
| Range | 5996000 |
| Interquartile range (IQR) | 41896 |
Descriptive statistics
| Standard deviation | 63793.76579 |
|---|---|
| Coefficient of variation (CV) | 0.9249638807 |
| Kurtosis | 2302.737777 |
| Mean | 68968.92638 |
| Median Absolute Deviation (MAD) | 20000 |
| Skewness | 30.9491846 |
| Sum | 2739238849 |
| Variance | 4069644554 |
| Value | Count | Frequency (%) | |
| 60000 | 1505 | 3.8% | |
| 50000 | 1057 | 2.7% | |
| 40000 | 876 | 2.2% | |
| 45000 | 830 | 2.1% | |
| 30000 | 825 | 2.1% | |
| 75000 | 811 | 2.0% | |
| 65000 | 803 | 2.0% | |
| 70000 | 733 | 1.8% | |
| 48000 | 723 | 1.8% | |
| 80000 | 662 | 1.7% | |
| Other values (5308) | 30892 | 77.8% |
| Value | Count | Frequency (%) | |
| 4000 | 1 | < 0.1% | |
| 4080 | 1 | < 0.1% | |
| 4200 | 2 | < 0.1% | |
| 4800 | 4 | < 0.1% | |
| 4888 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6000000 | 1 | < 0.1% | |
| 3900000 | 1 | < 0.1% | |
| 2039784 | 1 | < 0.1% | |
| 1900000 | 1 | < 0.1% | |
| 1782000 | 1 | < 0.1% |
verification_status
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| Not Verified | |
|---|---|
| Verified | |
| Source Verified |
| Value | Count | Frequency (%) | |
| Not Verified | 16921 | 42.6% | |
| Verified | 12809 | 32.3% | |
| Source Verified | 9987 | 25.1% |
Length
| Max length | 15 |
|---|---|
| Median length | 12 |
| Mean length | 11.46433517 |
| Min length | 8 |
| Distinct count | 55 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| Dec-11 | 2260 |
|---|---|
| Nov-11 | 2223 |
| Oct-11 | 2114 |
| Sep-11 | 2063 |
| Aug-11 | 1928 |
| Other values (50) |
| Value | Count | Frequency (%) | |
| Dec-11 | 2260 | 5.7% | |
| Nov-11 | 2223 | 5.6% | |
| Oct-11 | 2114 | 5.3% | |
| Sep-11 | 2063 | 5.2% | |
| Aug-11 | 1928 | 4.9% | |
| Jul-11 | 1870 | 4.7% | |
| Jun-11 | 1827 | 4.6% | |
| May-11 | 1689 | 4.3% | |
| Apr-11 | 1562 | 3.9% | |
| Mar-11 | 1443 | 3.6% | |
| Other values (45) | 20738 | 52.2% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
loan_status
Categorical
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| Fully Paid | |
|---|---|
| Charged Off | 5627 |
| Current | 1140 |
| Value | Count | Frequency (%) | |
| Fully Paid | 32950 | 83.0% | |
| Charged Off | 5627 | 14.2% | |
| Current | 1140 | 2.9% |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 10.05556814 |
| Min length | 7 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| n |
|---|
| Value | Count | Frequency (%) | |
| n | 39717 | 100.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 39717 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| https://lendingclub.com/browse/loanDetail.action?loan_id=876837 | 1 |
|---|---|
| https://lendingclub.com/browse/loanDetail.action?loan_id=621226 | 1 |
| https://lendingclub.com/browse/loanDetail.action?loan_id=775126 | 1 |
| https://lendingclub.com/browse/loanDetail.action?loan_id=450346 | 1 |
| https://lendingclub.com/browse/loanDetail.action?loan_id=550106 | 1 |
| Other values (39712) |
| Value | Count | Frequency (%) | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=876837 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=621226 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=775126 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=450346 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=550106 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=695876 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=445768 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=706813 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=1054165 | 1 | < 0.1% | |
| https://lendingclub.com/browse/loanDetail.action?loan_id=634825 | 1 | < 0.1% | |
| Other values (39707) | 39707 | > 99.9% |
| Value | Count | Frequency (%) | |
| https | 39717 | 100.0% |
| Value | Count | Frequency (%) | |
| lendingclub.com | 39717 | 100.0% |
| Value | Count | Frequency (%) | |
| /browse/loanDetail.action | 39717 | 100.0% |
| Value | Count | Frequency (%) | |
| loan_id=551957 | 1 | < 0.1% | |
| loan_id=829264 | 1 | < 0.1% | |
| loan_id=855311 | 1 | < 0.1% | |
| loan_id=457414 | 1 | < 0.1% | |
| loan_id=1022579 | 1 | < 0.1% | |
| loan_id=721594 | 1 | < 0.1% | |
| loan_id=889595 | 1 | < 0.1% | |
| loan_id=1000786 | 1 | < 0.1% | |
| loan_id=1057024 | 1 | < 0.1% | |
| loan_id=617431 | 1 | < 0.1% | |
| Other values (39707) | 39707 | > 99.9% |
| Value | Count | Frequency (%) | |
| 39717 | 100.0% |
purpose
Categorical
| Distinct count | 14 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| debt_consolidation | |
|---|---|
| credit_card | |
| other | |
| home_improvement | 2976 |
| major_purchase | 2187 |
| Other values (9) |
| Value | Count | Frequency (%) | |
| debt_consolidation | 18641 | 46.9% | |
| credit_card | 5130 | 12.9% | |
| other | 3993 | 10.1% | |
| home_improvement | 2976 | 7.5% | |
| major_purchase | 2187 | 5.5% | |
| small_business | 1828 | 4.6% | |
| car | 1549 | 3.9% | |
| wedding | 947 | 2.4% | |
| medical | 693 | 1.7% | |
| moving | 583 | 1.5% | |
| Other values (4) | 1190 | 3.0% |
Length
| Max length | 18 |
|---|---|
| Median length | 16 |
| Mean length | 13.7361835 |
| Min length | 3 |
| Distinct count | 19615 |
|---|---|
| Unique (%) | 49.4% |
| Missing | 11 |
| Missing (%) | < 0.1% |
| Memory size | 310.3 KiB |
| Debt Consolidation | 2184 |
|---|---|
| Debt Consolidation Loan | 1729 |
| Personal Loan | 659 |
| Consolidation | 517 |
| debt consolidation | 505 |
| Other values (19610) |
| Value | Count | Frequency (%) | |
| Debt Consolidation | 2184 | 5.5% | |
| Debt Consolidation Loan | 1729 | 4.4% | |
| Personal Loan | 659 | 1.7% | |
| Consolidation | 517 | 1.3% | |
| debt consolidation | 505 | 1.3% | |
| Home Improvement | 356 | 0.9% | |
| Credit Card Consolidation | 356 | 0.9% | |
| Debt consolidation | 334 | 0.8% | |
| Small Business Loan | 328 | 0.8% | |
| Credit Card Loan | 317 | 0.8% | |
| Other values (19605) | 32421 | 81.6% |
Length
| Max length | 80 |
|---|---|
| Median length | 16 |
| Mean length | 17.18339754 |
| Min length | 1 |
| Distinct count | 823 |
|---|---|
| Unique (%) | 2.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| 100xx | 597 |
|---|---|
| 945xx | 545 |
| 112xx | 516 |
| 606xx | 503 |
| 070xx | 473 |
| Other values (818) |
| Value | Count | Frequency (%) | |
| 100xx | 597 | 1.5% | |
| 945xx | 545 | 1.4% | |
| 112xx | 516 | 1.3% | |
| 606xx | 503 | 1.3% | |
| 070xx | 473 | 1.2% | |
| 900xx | 453 | 1.1% | |
| 021xx | 397 | 1.0% | |
| 300xx | 394 | 1.0% | |
| 926xx | 371 | 0.9% | |
| 750xx | 367 | 0.9% | |
| Other values (813) | 35101 | 88.4% |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
addr_state
Categorical
| Distinct count | 50 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| CA | |
|---|---|
| NY | 3812 |
| FL | 2866 |
| TX | 2727 |
| NJ | 1850 |
| Other values (45) |
| Value | Count | Frequency (%) | |
| CA | 7099 | 17.9% | |
| NY | 3812 | 9.6% | |
| FL | 2866 | 7.2% | |
| TX | 2727 | 6.9% | |
| NJ | 1850 | 4.7% | |
| IL | 1525 | 3.8% | |
| PA | 1517 | 3.8% | |
| VA | 1407 | 3.5% | |
| GA | 1398 | 3.5% | |
| MA | 1340 | 3.4% | |
| Other values (40) | 14176 | 35.7% |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
dti
Real number (ℝ≥0)
| Distinct count | 2868 |
|---|---|
| Unique (%) | 7.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.315129541506153 |
|---|---|
| Minimum | 0.0 |
| Maximum | 29.99 |
| Zeros | 183 |
| Zeros (%) | 0.5% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.13 |
| Q1 | 8.17 |
| median | 13.4 |
| Q3 | 18.6 |
| 95-th percentile | 23.84 |
| Maximum | 29.99 |
| Range | 29.99 |
| Interquartile range (IQR) | 10.43 |
Descriptive statistics
| Standard deviation | 6.678593595 |
|---|---|
| Coefficient of variation (CV) | 0.501579318 |
| Kurtosis | -0.8520154806 |
| Mean | 13.31512954 |
| Median Absolute Deviation (MAD) | 5.21 |
| Skewness | -0.02804333095 |
| Sum | 528837 |
| Variance | 44.6036124 |
| Value | Count | Frequency (%) | |
| 0 | 183 | 0.5% | |
| 12 | 51 | 0.1% | |
| 18 | 45 | 0.1% | |
| 19.2 | 40 | 0.1% | |
| 13.2 | 39 | 0.1% | |
| 13.5 | 38 | 0.1% | |
| 12.48 | 38 | 0.1% | |
| 16.8 | 38 | 0.1% | |
| 6 | 37 | 0.1% | |
| 14.29 | 36 | 0.1% | |
| Other values (2858) | 39172 | 98.6% |
| Value | Count | Frequency (%) | |
| 0 | 183 | 0.5% | |
| 0.01 | 3 | < 0.1% | |
| 0.02 | 5 | < 0.1% | |
| 0.03 | 2 | < 0.1% | |
| 0.04 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 29.99 | 1 | < 0.1% | |
| 29.95 | 1 | < 0.1% | |
| 29.93 | 3 | < 0.1% | |
| 29.92 | 2 | < 0.1% | |
| 29.89 | 1 | < 0.1% |
| Distinct count | 11 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1465115693531737 |
|---|---|
| Minimum | 0 |
| Maximum | 11 |
| Zeros | 35405 |
| Zeros (%) | 89.1% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 11 |
| Range | 11 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.491811516 |
|---|---|
| Coefficient of variation (CV) | 3.356810102 |
| Kurtosis | 39.41249957 |
| Mean | 0.1465115694 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.022035213 |
| Sum | 5819 |
| Variance | 0.2418785673 |
| Value | Count | Frequency (%) | |
| 0 | 35405 | 89.1% | |
| 1 | 3303 | 8.3% | |
| 2 | 687 | 1.7% | |
| 3 | 220 | 0.6% | |
| 4 | 62 | 0.2% | |
| 5 | 22 | 0.1% | |
| 6 | 10 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 11 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 35405 | 89.1% | |
| 1 | 3303 | 8.3% | |
| 2 | 687 | 1.7% | |
| 3 | 220 | 0.6% | |
| 4 | 62 | 0.2% |
| Value | Count | Frequency (%) | |
| 11 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 8 | 2 | < 0.1% | |
| 7 | 4 | < 0.1% | |
| 6 | 10 | < 0.1% |
| Distinct count | 526 |
|---|---|
| Unique (%) | 1.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| Nov-98 | 370 |
|---|---|
| Oct-99 | 366 |
| Dec-98 | 348 |
| Oct-00 | 346 |
| Dec-97 | 329 |
| Other values (521) |
| Value | Count | Frequency (%) | |
| Nov-98 | 370 | 0.9% | |
| Oct-99 | 366 | 0.9% | |
| Dec-98 | 348 | 0.9% | |
| Oct-00 | 346 | 0.9% | |
| Dec-97 | 329 | 0.8% | |
| Nov-00 | 320 | 0.8% | |
| Nov-99 | 319 | 0.8% | |
| Sep-00 | 306 | 0.8% | |
| Oct-98 | 305 | 0.8% | |
| Nov-97 | 298 | 0.8% | |
| Other values (516) | 36410 | 91.7% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
| Distinct count | 9 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8691995870785809 |
|---|---|
| Minimum | 0 |
| Maximum | 8 |
| Zeros | 19300 |
| Zeros (%) | 48.6% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 3 |
| Maximum | 8 |
| Range | 8 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.070219332 |
|---|---|
| Coefficient of variation (CV) | 1.23126995 |
| Kurtosis | 2.562159858 |
| Mean | 0.8691995871 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.390390927 |
| Sum | 34522 |
| Variance | 1.145369419 |
| Value | Count | Frequency (%) | |
| 0 | 19300 | 48.6% | |
| 1 | 10971 | 27.6% | |
| 2 | 5812 | 14.6% | |
| 3 | 3048 | 7.7% | |
| 4 | 326 | 0.8% | |
| 5 | 146 | 0.4% | |
| 6 | 64 | 0.2% | |
| 7 | 35 | 0.1% | |
| 8 | 15 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 19300 | 48.6% | |
| 1 | 10971 | 27.6% | |
| 2 | 5812 | 14.6% | |
| 3 | 3048 | 7.7% | |
| 4 | 326 | 0.8% |
| Value | Count | Frequency (%) | |
| 8 | 15 | < 0.1% | |
| 7 | 35 | 0.1% | |
| 6 | 64 | 0.2% | |
| 5 | 146 | 0.4% | |
| 4 | 326 | 0.8% |
open_acc
Real number (ℝ≥0)
| Distinct count | 40 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.294407936148248 |
|---|---|
| Minimum | 2 |
| Maximum | 44 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 6 |
| median | 9 |
| Q3 | 12 |
| 95-th percentile | 17 |
| Maximum | 44 |
| Range | 42 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 4.400282474 |
|---|---|
| Coefficient of variation (CV) | 0.4734333272 |
| Kurtosis | 1.67757203 |
| Mean | 9.294407936 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.00376191 |
| Sum | 369146 |
| Variance | 19.36248585 |
| Value | Count | Frequency (%) | |
| 7 | 4018 | 10.1% | |
| 6 | 3946 | 9.9% | |
| 8 | 3936 | 9.9% | |
| 9 | 3718 | 9.4% | |
| 10 | 3223 | 8.1% | |
| 5 | 3183 | 8.0% | |
| 11 | 2746 | 6.9% | |
| 4 | 2343 | 5.9% | |
| 12 | 2273 | 5.7% | |
| 13 | 1911 | 4.8% | |
| Other values (30) | 8420 | 21.2% |
| Value | Count | Frequency (%) | |
| 2 | 605 | 1.5% | |
| 3 | 1493 | 3.8% | |
| 4 | 2343 | 5.9% | |
| 5 | 3183 | 8.0% | |
| 6 | 3946 | 9.9% |
| Value | Count | Frequency (%) | |
| 44 | 1 | < 0.1% | |
| 42 | 1 | < 0.1% | |
| 41 | 1 | < 0.1% | |
| 39 | 1 | < 0.1% | |
| 38 | 1 | < 0.1% |
| Distinct count | 5 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.055064581917063225 |
|---|---|
| Minimum | 0 |
| Maximum | 4 |
| Zeros | 37601 |
| Zeros (%) | 94.7% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 4 |
| Range | 4 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.2371999517 |
|---|---|
| Coefficient of variation (CV) | 4.307668259 |
| Kurtosis | 23.88943797 |
| Mean | 0.05506458192 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 4.538051316 |
| Sum | 2187 |
| Variance | 0.05626381708 |
| Value | Count | Frequency (%) | |
| 0 | 37601 | 94.7% | |
| 1 | 2056 | 5.2% | |
| 2 | 51 | 0.1% | |
| 3 | 7 | < 0.1% | |
| 4 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 0 | 37601 | 94.7% | |
| 1 | 2056 | 5.2% | |
| 2 | 51 | 0.1% | |
| 3 | 7 | < 0.1% | |
| 4 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 4 | 2 | < 0.1% | |
| 3 | 7 | < 0.1% | |
| 2 | 51 | 0.1% | |
| 1 | 2056 | 5.2% | |
| 0 | 37601 | 94.7% |
| Distinct count | 21711 |
|---|---|
| Unique (%) | 54.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13382.528086209935 |
|---|---|
| Minimum | 0 |
| Maximum | 149588 |
| Zeros | 994 |
| Zeros (%) | 2.5% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 321.8 |
| Q1 | 3703 |
| median | 8850 |
| Q3 | 17058 |
| 95-th percentile | 41656.4 |
| Maximum | 149588 |
| Range | 149588 |
| Interquartile range (IQR) | 13355 |
Descriptive statistics
| Standard deviation | 15885.01664 |
|---|---|
| Coefficient of variation (CV) | 1.186996697 |
| Kurtosis | 14.89652278 |
| Mean | 13382.52809 |
| Median Absolute Deviation (MAD) | 6027 |
| Skewness | 3.190883683 |
| Sum | 531513868 |
| Variance | 252333753.7 |
| Value | Count | Frequency (%) | |
| 0 | 994 | 2.5% | |
| 255 | 14 | < 0.1% | |
| 298 | 14 | < 0.1% | |
| 1 | 12 | < 0.1% | |
| 682 | 11 | < 0.1% | |
| 39 | 9 | < 0.1% | |
| 865 | 9 | < 0.1% | |
| 1159 | 9 | < 0.1% | |
| 1763 | 9 | < 0.1% | |
| 10 | 9 | < 0.1% | |
| Other values (21701) | 38627 | 97.3% |
| Value | Count | Frequency (%) | |
| 0 | 994 | 2.5% | |
| 1 | 12 | < 0.1% | |
| 2 | 5 | < 0.1% | |
| 3 | 6 | < 0.1% | |
| 4 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 149588 | 1 | < 0.1% | |
| 149527 | 1 | < 0.1% | |
| 149000 | 1 | < 0.1% | |
| 148829 | 1 | < 0.1% | |
| 148804 | 1 | < 0.1% |
| Distinct count | 1089 |
|---|---|
| Unique (%) | 2.7% |
| Missing | 50 |
| Missing (%) | 0.1% |
| Memory size | 310.3 KiB |
| 0% | 977 |
|---|---|
| 0.20% | 63 |
| 63% | 62 |
| 66.70% | 58 |
| 40.70% | 58 |
| Other values (1084) |
| Value | Count | Frequency (%) | |
| 0% | 977 | 2.5% | |
| 0.20% | 63 | 0.2% | |
| 63% | 62 | 0.2% | |
| 66.70% | 58 | 0.1% | |
| 40.70% | 58 | 0.1% | |
| 0.10% | 58 | 0.1% | |
| 66.60% | 57 | 0.1% | |
| 46.40% | 57 | 0.1% | |
| 31.20% | 57 | 0.1% | |
| 61% | 57 | 0.1% | |
| Other values (1079) | 38163 | 96.1% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.518745122 |
| Min length | 2 |
total_acc
Real number (ℝ≥0)
| Distinct count | 82 |
|---|---|
| Unique (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.08882846136415 |
|---|---|
| Minimum | 2 |
| Maximum | 90 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 7 |
| Q1 | 13 |
| median | 20 |
| Q3 | 29 |
| 95-th percentile | 43 |
| Maximum | 90 |
| Range | 88 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 11.40170855 |
|---|---|
| Coefficient of variation (CV) | 0.5161753405 |
| Kurtosis | 0.6937402027 |
| Mean | 22.08882846 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.8273790855 |
| Sum | 877302 |
| Variance | 129.9989579 |
| Value | Count | Frequency (%) | |
| 16 | 1471 | 3.7% | |
| 15 | 1462 | 3.7% | |
| 17 | 1457 | 3.7% | |
| 14 | 1445 | 3.6% | |
| 20 | 1428 | 3.6% | |
| 18 | 1422 | 3.6% | |
| 21 | 1412 | 3.6% | |
| 13 | 1385 | 3.5% | |
| 19 | 1341 | 3.4% | |
| 12 | 1325 | 3.3% | |
| Other values (72) | 25569 | 64.4% |
| Value | Count | Frequency (%) | |
| 2 | 4 | < 0.1% | |
| 3 | 182 | 0.5% | |
| 4 | 420 | 1.1% | |
| 5 | 552 | 1.4% | |
| 6 | 683 | 1.7% |
| Value | Count | Frequency (%) | |
| 90 | 1 | < 0.1% | |
| 87 | 1 | < 0.1% | |
| 81 | 1 | < 0.1% | |
| 80 | 1 | < 0.1% | |
| 79 | 2 | < 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| f |
|---|
| Value | Count | Frequency (%) | |
| f | 39717 | 100.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 1137 |
|---|---|
| Unique (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51.22788730266637 |
|---|---|
| Minimum | 0.0 |
| Maximum | 6311.47 |
| Zeros | 38577 |
| Zeros (%) | 97.1% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 6311.47 |
| Range | 6311.47 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 375.1728389 |
|---|---|
| Coefficient of variation (CV) | 7.323605532 |
| Kurtosis | 97.6585546 |
| Mean | 51.2278873 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.226730006 |
| Sum | 2034618 |
| Variance | 140754.659 |
| Value | Count | Frequency (%) | |
| 0 | 38577 | 97.1% | |
| 827.13 | 2 | < 0.1% | |
| 2277.11 | 2 | < 0.1% | |
| 1972.6 | 2 | < 0.1% | |
| 2963.24 | 2 | < 0.1% | |
| 749.32 | 1 | < 0.1% | |
| 1204.88 | 1 | < 0.1% | |
| 942.68 | 1 | < 0.1% | |
| 2812.85 | 1 | < 0.1% | |
| 2853.89 | 1 | < 0.1% | |
| Other values (1127) | 1127 | 2.8% |
| Value | Count | Frequency (%) | |
| 0 | 38577 | 97.1% | |
| 10.26 | 1 | < 0.1% | |
| 11.91 | 1 | < 0.1% | |
| 13.28 | 1 | < 0.1% | |
| 19.12 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6311.47 | 1 | < 0.1% | |
| 6308.37 | 1 | < 0.1% | |
| 6307.37 | 1 | < 0.1% | |
| 6307.15 | 1 | < 0.1% | |
| 6219.16 | 1 | < 0.1% |
| Distinct count | 1138 |
|---|---|
| Unique (%) | 2.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50.98976810937382 |
|---|---|
| Minimum | 0.0 |
| Maximum | 6307.37 |
| Zeros | 38577 |
| Zeros (%) | 97.1% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 6307.37 |
| Range | 6307.37 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 373.8244569 |
|---|---|
| Coefficient of variation (CV) | 7.331362169 |
| Kurtosis | 98.04055348 |
| Mean | 50.98976811 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.243765495 |
| Sum | 2025160.62 |
| Variance | 139744.7246 |
| Value | Count | Frequency (%) | |
| 0 | 38577 | 97.1% | |
| 1972.6 | 2 | < 0.1% | |
| 827.13 | 2 | < 0.1% | |
| 1664.64 | 2 | < 0.1% | |
| 1143.7 | 1 | < 0.1% | |
| 4527.01 | 1 | < 0.1% | |
| 2095.61 | 1 | < 0.1% | |
| 332.47 | 1 | < 0.1% | |
| 804.39 | 1 | < 0.1% | |
| 815.07 | 1 | < 0.1% | |
| Other values (1128) | 1128 | 2.8% |
| Value | Count | Frequency (%) | |
| 0 | 38577 | 97.1% | |
| 10.26 | 1 | < 0.1% | |
| 11.91 | 1 | < 0.1% | |
| 13.28 | 1 | < 0.1% | |
| 19.09 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 6307.37 | 1 | < 0.1% | |
| 6306.96 | 1 | < 0.1% | |
| 6298.11 | 1 | < 0.1% | |
| 6276.75 | 1 | < 0.1% | |
| 6219.16 | 1 | < 0.1% |
| Distinct count | 37850 |
|---|---|
| Unique (%) | 95.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12153.596543630887 |
|---|---|
| Minimum | 0.0 |
| Maximum | 58563.67993 |
| Zeros | 16 |
| Zeros (%) | < 0.1% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1887.957036 |
| Q1 | 5576.93 |
| median | 9899.640319 |
| Q3 | 16534.43304 |
| 95-th percentile | 30245.11853 |
| Maximum | 58563.67993 |
| Range | 58563.67993 |
| Interquartile range (IQR) | 10957.50304 |
Descriptive statistics
| Standard deviation | 9042.040766 |
|---|---|
| Coefficient of variation (CV) | 0.743980659 |
| Kurtosis | 1.985894249 |
| Mean | 12153.59654 |
| Median Absolute Deviation (MAD) | 5016.756711 |
| Skewness | 1.339857366 |
| Sum | 482704393.9 |
| Variance | 81758501.21 |
| Value | Count | Frequency (%) | |
| 11196.56943 | 26 | 0.1% | |
| 0 | 16 | < 0.1% | |
| 11784.23223 | 16 | < 0.1% | |
| 10956.77596 | 16 | < 0.1% | |
| 13148.13786 | 15 | < 0.1% | |
| 5478.387981 | 15 | < 0.1% | |
| 13435.90021 | 13 | < 0.1% | |
| 5557.025543 | 13 | < 0.1% | |
| 13263.95464 | 12 | < 0.1% | |
| 5598.284713 | 11 | < 0.1% | |
| Other values (37840) | 39564 | 99.6% |
| Value | Count | Frequency (%) | |
| 0 | 16 | < 0.1% | |
| 33.73 | 1 | < 0.1% | |
| 35.71 | 1 | < 0.1% | |
| 44.92 | 2 | < 0.1% | |
| 44.96 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 58563.67993 | 1 | < 0.1% | |
| 58480.13992 | 1 | < 0.1% | |
| 57835.27991 | 1 | < 0.1% | |
| 56849.26986 | 1 | < 0.1% | |
| 56662.58994 | 1 | < 0.1% |
| Distinct count | 37518 |
|---|---|
| Unique (%) | 94.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11567.149118009922 |
|---|---|
| Minimum | 0.0 |
| Maximum | 58563.68 |
| Zeros | 165 |
| Zeros (%) | 0.4% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1420.408 |
| Q1 | 5112.31 |
| median | 9287.15 |
| Q3 | 15798.81 |
| 95-th percentile | 29627.236 |
| Maximum | 58563.68 |
| Range | 58563.68 |
| Interquartile range (IQR) | 10686.5 |
Descriptive statistics
| Standard deviation | 8942.672613 |
|---|---|
| Coefficient of variation (CV) | 0.7731094777 |
| Kurtosis | 2.029758507 |
| Mean | 11567.14912 |
| Median Absolute Deviation (MAD) | 4939.58 |
| Skewness | 1.35483764 |
| Sum | 459412461.5 |
| Variance | 79971393.47 |
| Value | Count | Frequency (%) | |
| 0 | 165 | 0.4% | |
| 6514.52 | 16 | < 0.1% | |
| 13148.14 | 14 | < 0.1% | |
| 5478.39 | 14 | < 0.1% | |
| 11196.57 | 12 | < 0.1% | |
| 10956.78 | 12 | < 0.1% | |
| 6717.95 | 12 | < 0.1% | |
| 7328.92 | 11 | < 0.1% | |
| 13517.36 | 11 | < 0.1% | |
| 5557.03 | 11 | < 0.1% | |
| Other values (37508) | 39439 | 99.3% |
| Value | Count | Frequency (%) | |
| 0 | 165 | 0.4% | |
| 0.54 | 1 | < 0.1% | |
| 12.65 | 1 | < 0.1% | |
| 18.97 | 1 | < 0.1% | |
| 21.6 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 58563.68 | 1 | < 0.1% | |
| 58438.37 | 1 | < 0.1% | |
| 57628.73 | 1 | < 0.1% | |
| 56622.12 | 1 | < 0.1% | |
| 56515.16 | 1 | < 0.1% |
| Distinct count | 7976 |
|---|---|
| Unique (%) | 20.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9793.348813102702 |
|---|---|
| Minimum | 0.0 |
| Maximum | 35000.02 |
| Zeros | 74 |
| Zeros (%) | 0.2% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1339.842 |
| Q1 | 4600 |
| median | 8000 |
| Q3 | 13653.26 |
| 95-th percentile | 24999.982 |
| Maximum | 35000.02 |
| Range | 35000.02 |
| Interquartile range (IQR) | 9053.26 |
Descriptive statistics
| Standard deviation | 7065.522127 |
|---|---|
| Coefficient of variation (CV) | 0.7214612961 |
| Kurtosis | 1.103355455 |
| Mean | 9793.348813 |
| Median Absolute Deviation (MAD) | 4000 |
| Skewness | 1.118254546 |
| Sum | 388962434.8 |
| Variance | 49921602.93 |
| Value | Count | Frequency (%) | |
| 10000 | 2293 | 5.8% | |
| 12000 | 1805 | 4.5% | |
| 5000 | 1702 | 4.3% | |
| 6000 | 1637 | 4.1% | |
| 15000 | 1400 | 3.5% | |
| 8000 | 1318 | 3.3% | |
| 20000 | 1059 | 2.7% | |
| 4000 | 956 | 2.4% | |
| 3000 | 883 | 2.2% | |
| 7000 | 851 | 2.1% | |
| Other values (7966) | 25813 | 65.0% |
| Value | Count | Frequency (%) | |
| 0 | 74 | 0.2% | |
| 21.21 | 1 | < 0.1% | |
| 21.93 | 1 | < 0.1% | |
| 22.24 | 1 | < 0.1% | |
| 22.5 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 35000.02 | 2 | < 0.1% | |
| 35000.01 | 1 | < 0.1% | |
| 35000 | 363 | 0.9% | |
| 34999.99 | 5 | < 0.1% | |
| 34999.98 | 1 | < 0.1% |
total_rec_int
Real number (ℝ≥0)
| Distinct count | 35148 |
|---|---|
| Unique (%) | 88.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2263.6631721932677 |
|---|---|
| Minimum | 0.0 |
| Maximum | 23563.68 |
| Zeros | 71 |
| Zeros (%) | 0.2% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 186.168 |
| Q1 | 662.18 |
| median | 1348.91 |
| Q3 | 2833.4 |
| 95-th percentile | 7575.812 |
| Maximum | 23563.68 |
| Range | 23563.68 |
| Interquartile range (IQR) | 2171.22 |
Descriptive statistics
| Standard deviation | 2608.111964 |
|---|---|
| Coefficient of variation (CV) | 1.152164331 |
| Kurtosis | 9.688278395 |
| Mean | 2263.663172 |
| Median Absolute Deviation (MAD) | 866.01 |
| Skewness | 2.668747187 |
| Sum | 89905910.21 |
| Variance | 6802248.019 |
| Value | Count | Frequency (%) | |
| 0 | 71 | 0.2% | |
| 1196.57 | 26 | 0.1% | |
| 514.52 | 19 | < 0.1% | |
| 1784.23 | 17 | < 0.1% | |
| 956.78 | 17 | < 0.1% | |
| 1148.14 | 17 | < 0.1% | |
| 717.95 | 17 | < 0.1% | |
| 478.39 | 16 | < 0.1% | |
| 1907.35 | 14 | < 0.1% | |
| 557.03 | 13 | < 0.1% | |
| Other values (35138) | 39490 | 99.4% |
| Value | Count | Frequency (%) | |
| 0 | 71 | 0.2% | |
| 6.22 | 1 | < 0.1% | |
| 6.27 | 1 | < 0.1% | |
| 7.19 | 1 | < 0.1% | |
| 7.2 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 23563.68 | 1 | < 0.1% | |
| 23506.56 | 1 | < 0.1% | |
| 23480.14 | 1 | < 0.1% | |
| 22835.28 | 1 | < 0.1% | |
| 22716.42 | 1 | < 0.1% |
| Distinct count | 1356 |
|---|---|
| Unique (%) | 3.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.3630152124181836 |
|---|---|
| Minimum | 0.0 |
| Maximum | 180.2 |
| Zeros | 37671 |
| Zeros (%) | 94.8% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 14.924199 |
| Maximum | 180.2 |
| Range | 180.2 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7.289979302 |
|---|---|
| Coefficient of variation (CV) | 5.348421085 |
| Kurtosis | 100.8515437 |
| Mean | 1.363015212 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 8.429536 |
| Sum | 54134.87519 |
| Variance | 53.14379822 |
| Value | Count | Frequency (%) | |
| 0 | 37671 | 94.8% | |
| 15 | 255 | 0.6% | |
| 15.00000001 | 58 | 0.1% | |
| 30 | 55 | 0.1% | |
| 15.00000002 | 47 | 0.1% | |
| 14.99999999 | 40 | 0.1% | |
| 14.99999998 | 33 | 0.1% | |
| 15.00000003 | 32 | 0.1% | |
| 15.00000004 | 25 | 0.1% | |
| 14.99999997 | 25 | 0.1% | |
| Other values (1346) | 1476 | 3.7% |
| Value | Count | Frequency (%) | |
| 0 | 37671 | 94.8% | |
| 0.01 | 1 | < 0.1% | |
| 0.060799751 | 1 | < 0.1% | |
| 0.073787104 | 1 | < 0.1% | |
| 0.101704562 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 180.2 | 1 | < 0.1% | |
| 166.4297107 | 1 | < 0.1% | |
| 165.69 | 1 | < 0.1% | |
| 146.6000003 | 1 | < 0.1% | |
| 146.04 | 1 | < 0.1% |
| Distinct count | 4040 |
|---|---|
| Unique (%) | 10.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 95.22162387467331 |
|---|---|
| Minimum | 0.0 |
| Maximum | 29623.35 |
| Zeros | 35499 |
| Zeros (%) | 89.4% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 362.418 |
| Maximum | 29623.35 |
| Range | 29623.35 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 688.744771 |
|---|---|
| Coefficient of variation (CV) | 7.23307105 |
| Kurtosis | 379.3775773 |
| Mean | 95.22162387 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.5193782 |
| Sum | 3781917.235 |
| Variance | 474369.3595 |
| Value | Count | Frequency (%) | |
| 0 | 35499 | 89.4% | |
| 10.4 | 4 | < 0.1% | |
| 11.29 | 4 | < 0.1% | |
| 19.2 | 3 | < 0.1% | |
| 13.59 | 3 | < 0.1% | |
| 11.2 | 3 | < 0.1% | |
| 10.66 | 3 | < 0.1% | |
| 13.93 | 3 | < 0.1% | |
| 13.44 | 3 | < 0.1% | |
| 44.92 | 3 | < 0.1% | |
| Other values (4030) | 4189 | 10.5% |
| Value | Count | Frequency (%) | |
| 0 | 35499 | 89.4% | |
| 6.3 | 1 | < 0.1% | |
| 6.31 | 1 | < 0.1% | |
| 8.19 | 1 | < 0.1% | |
| 8.36 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 29623.35 | 1 | < 0.1% | |
| 22943.37 | 1 | < 0.1% | |
| 21810.31 | 1 | < 0.1% | |
| 20006.53 | 1 | < 0.1% | |
| 19915.67 | 1 | < 0.1% |
| Distinct count | 2616 |
|---|---|
| Unique (%) | 6.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12.406111894151396 |
|---|---|
| Minimum | 0.0 |
| Maximum | 7002.19 |
| Zeros | 35935 |
| Zeros (%) | 90.5% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 5.152 |
| Maximum | 7002.19 |
| Range | 7002.19 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 148.6715935 |
|---|---|
| Coefficient of variation (CV) | 11.98373791 |
| Kurtosis | 821.3006591 |
| Mean | 12.40611189 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 25.02941842 |
| Sum | 492733.5461 |
| Variance | 22103.2427 |
| Value | Count | Frequency (%) | |
| 0 | 35935 | 90.5% | |
| 2 | 12 | < 0.1% | |
| 1.2 | 10 | < 0.1% | |
| 3.71 | 9 | < 0.1% | |
| 1.88 | 8 | < 0.1% | |
| 2.52 | 8 | < 0.1% | |
| 2.02 | 8 | < 0.1% | |
| 1.21 | 8 | < 0.1% | |
| 1.69 | 8 | < 0.1% | |
| 1.6 | 8 | < 0.1% | |
| Other values (2606) | 3703 | 9.3% |
| Value | Count | Frequency (%) | |
| 0 | 35935 | 90.5% | |
| 0.063 | 1 | < 0.1% | |
| 0.074500001 | 1 | < 0.1% | |
| 0.134799995 | 1 | < 0.1% | |
| 0.1393 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 7002.19 | 1 | < 0.1% | |
| 6972.59 | 1 | < 0.1% | |
| 6543.04 | 1 | < 0.1% | |
| 5774.8 | 1 | < 0.1% | |
| 5602.72 | 1 | < 0.1% |
| Distinct count | 101 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 71 |
| Missing (%) | 0.2% |
| Memory size | 310.3 KiB |
| May-16 | 1256 |
|---|---|
| Mar-13 | 1026 |
| Dec-14 | 945 |
| May-13 | 907 |
| Feb-13 | 869 |
| Other values (96) |
| Value | Count | Frequency (%) | |
| May-16 | 1256 | 3.2% | |
| Mar-13 | 1026 | 2.6% | |
| Dec-14 | 945 | 2.4% | |
| May-13 | 907 | 2.3% | |
| Feb-13 | 869 | 2.2% | |
| Apr-13 | 851 | 2.1% | |
| Mar-12 | 844 | 2.1% | |
| Aug-14 | 832 | 2.1% | |
| Jan-14 | 832 | 2.1% | |
| Aug-12 | 832 | 2.1% | |
| Other values (91) | 30452 | 76.7% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.994637057 |
| Min length | 3 |
last_pymnt_amnt
Real number (ℝ≥0)
| Distinct count | 34930 |
|---|---|
| Unique (%) | 87.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2678.826162348616 |
|---|---|
| Minimum | 0.0 |
| Maximum | 36115.2 |
| Zeros | 74 |
| Zeros (%) | 0.2% |
| Memory size | 310.3 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 43.34 |
| Q1 | 218.68 |
| median | 546.14 |
| Q3 | 3293.16 |
| 95-th percentile | 12183.944 |
| Maximum | 36115.2 |
| Range | 36115.2 |
| Interquartile range (IQR) | 3074.48 |
Descriptive statistics
| Standard deviation | 4447.136012 |
|---|---|
| Coefficient of variation (CV) | 1.660106234 |
| Kurtosis | 8.867819694 |
| Mean | 2678.826162 |
| Median Absolute Deviation (MAD) | 449.45 |
| Skewness | 2.712122241 |
| Sum | 106394938.7 |
| Variance | 19777018.71 |
| Value | Count | Frequency (%) | |
| 0 | 74 | 0.2% | |
| 276.06 | 21 | 0.1% | |
| 200 | 17 | < 0.1% | |
| 50 | 16 | < 0.1% | |
| 100 | 15 | < 0.1% | |
| 400 | 12 | < 0.1% | |
| 773.44 | 12 | < 0.1% | |
| 786.01 | 11 | < 0.1% | |
| 150 | 11 | < 0.1% | |
| 500 | 11 | < 0.1% | |
| Other values (34920) | 39517 | 99.5% |
| Value | Count | Frequency (%) | |
| 0 | 74 | 0.2% | |
| 0.01 | 1 | < 0.1% | |
| 0.02 | 1 | < 0.1% | |
| 0.03 | 1 | < 0.1% | |
| 0.13 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 36115.2 | 1 | < 0.1% | |
| 35613.68 | 1 | < 0.1% | |
| 35596.41 | 1 | < 0.1% | |
| 35479.89 | 1 | < 0.1% | |
| 35471.86 | 1 | < 0.1% |
| Distinct count | 106 |
|---|---|
| Unique (%) | 0.3% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 310.3 KiB |
| May-16 | |
|---|---|
| Apr-16 | 2547 |
| Mar-16 | 1123 |
| Feb-13 | 843 |
| Feb-16 | 736 |
| Other values (101) |
| Value | Count | Frequency (%) | |
| May-16 | 10308 | 26.0% | |
| Apr-16 | 2547 | 6.4% | |
| Mar-16 | 1123 | 2.8% | |
| Feb-13 | 843 | 2.1% | |
| Feb-16 | 736 | 1.9% | |
| Jan-16 | 657 | 1.7% | |
| Dec-15 | 647 | 1.6% | |
| Mar-13 | 577 | 1.5% | |
| Mar-14 | 564 | 1.4% | |
| Dec-14 | 562 | 1.4% | |
| Other values (96) | 21151 | 53.3% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 5.999848931 |
| Min length | 3 |
collections_12_mths_ex_med
Boolean
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 56 |
| Missing (%) | 0.1% |
| Memory size | 310.3 KiB |
| 0 | |
|---|---|
| (Missing) | 56 |
| Value | Count | Frequency (%) | |
| 0 | 39661 | 99.9% | |
| (Missing) | 56 | 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| 1 |
|---|
| Value | Count | Frequency (%) | |
| 1 | 39717 | 100.0% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| INDIVIDUAL |
|---|
| Value | Count | Frequency (%) | |
| INDIVIDUAL | 39717 | 100.0% |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 39717 | 100.0% |
chargeoff_within_12_mths
Boolean
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 56 |
| Missing (%) | 0.1% |
| Memory size | 310.3 KiB |
| 0 | |
|---|---|
| (Missing) | 56 |
| Value | Count | Frequency (%) | |
| 0 | 39661 | 99.9% | |
| (Missing) | 56 | 0.1% |
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 310.3 KiB |
| 0 |
|---|
| Value | Count | Frequency (%) | |
| 0 | 39717 | 100.0% |
| Distinct count | 3 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 697 |
| Missing (%) | 1.8% |
| Memory size | 310.3 KiB |
| 0 | |
|---|---|
| 1 | 1674 |
| 2 | 7 |
| Value | Count | Frequency (%) | |
| 0 | 37339 | 94.0% | |
| 1 | 1674 | 4.2% | |
| 2 | 7 | < 0.1% | |
| (Missing) | 697 | 1.8% |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
tax_liens
Boolean
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 39 |
| Missing (%) | 0.1% |
| Memory size | 310.3 KiB |
| 0 | |
|---|---|
| (Missing) | 39 |
| Value | Count | Frequency (%) | |
| 0 | 39678 | 99.9% | |
| (Missing) | 39 | 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| id | member_id | loan_amnt | funded_amnt | funded_amnt_inv | term | int_rate | installment | grade | sub_grade | emp_title | emp_length | home_ownership | annual_inc | verification_status | issue_d | loan_status | pymnt_plan | url | purpose | title | zip_code | addr_state | dti | delinq_2yrs | earliest_cr_line | inq_last_6mths | open_acc | pub_rec | revol_bal | revol_util | total_acc | initial_list_status | out_prncp | out_prncp_inv | total_pymnt | total_pymnt_inv | total_rec_prncp | total_rec_int | total_rec_late_fee | recoveries | collection_recovery_fee | last_pymnt_d | last_pymnt_amnt | last_credit_pull_d | collections_12_mths_ex_med | policy_code | application_type | acc_now_delinq | chargeoff_within_12_mths | delinq_amnt | pub_rec_bankruptcies | tax_liens | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1077501 | 1296599 | 5000 | 5000 | 4975.0 | 36 months | 10.65% | 162.87 | B | B2 | NaN | 10+ years | RENT | 24000.0 | Verified | Dec-11 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1077501 | credit_card | Computer | 860xx | AZ | 27.65 | 0 | Jan-85 | 1 | 3 | 0 | 13648 | 83.70% | 9 | f | 0.00 | 0.00 | 5863.155187 | 5833.84 | 5000.00 | 863.16 | 0.00 | 0.00 | 0.00 | Jan-15 | 171.62 | May-16 | 0.0 | 1 | INDIVIDUAL | 0 | 0.0 | 0 | 0.0 | 0.0 |
| 1 | 1077430 | 1314167 | 2500 | 2500 | 2500.0 | 60 months | 15.27% | 59.83 | C | C4 | Ryder | < 1 year | RENT | 30000.0 | Source Verified | Dec-11 | Charged Off | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1077430 | car | bike | 309xx | GA | 1.00 | 0 | Apr-99 | 5 | 3 | 0 | 1687 | 9.40% | 4 | f | 0.00 | 0.00 | 1008.710000 | 1008.71 | 456.46 | 435.17 | 0.00 | 117.08 | 1.11 | Apr-13 | 119.66 | Sep-13 | 0.0 | 1 | INDIVIDUAL | 0 | 0.0 | 0 | 0.0 | 0.0 |
| 2 | 1077175 | 1313524 | 2400 | 2400 | 2400.0 | 36 months | 15.96% | 84.33 | C | C5 | NaN | 10+ years | RENT | 12252.0 | Not Verified | Dec-11 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1077175 | small_business | real estate business | 606xx | IL | 8.72 | 0 | Nov-01 | 2 | 2 | 0 | 2956 | 98.50% | 10 | f | 0.00 | 0.00 | 3005.666844 | 3005.67 | 2400.00 | 605.67 | 0.00 | 0.00 | 0.00 | Jun-14 | 649.91 | May-16 | 0.0 | 1 | INDIVIDUAL | 0 | 0.0 | 0 | 0.0 | 0.0 |
| 3 | 1076863 | 1277178 | 10000 | 10000 | 10000.0 | 36 months | 13.49% | 339.31 | C | C1 | AIR RESOURCES BOARD | 10+ years | RENT | 49200.0 | Source Verified | Dec-11 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1076863 | other | personel | 917xx | CA | 20.00 | 0 | Feb-96 | 1 | 10 | 0 | 5598 | 21% | 37 | f | 0.00 | 0.00 | 12231.890000 | 12231.89 | 10000.00 | 2214.92 | 16.97 | 0.00 | 0.00 | Jan-15 | 357.48 | Apr-16 | 0.0 | 1 | INDIVIDUAL | 0 | 0.0 | 0 | 0.0 | 0.0 |
| 4 | 1075358 | 1311748 | 3000 | 3000 | 3000.0 | 60 months | 12.69% | 67.79 | B | B5 | University Medical Group | 1 year | RENT | 80000.0 | Source Verified | Dec-11 | Current | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1075358 | other | Personal | 972xx | OR | 17.94 | 0 | Jan-96 | 0 | 15 | 0 | 27783 | 53.90% | 38 | f | 524.06 | 524.06 | 3513.330000 | 3513.33 | 2475.94 | 1037.39 | 0.00 | 0.00 | 0.00 | May-16 | 67.79 | May-16 | 0.0 | 1 | INDIVIDUAL | 0 | 0.0 | 0 | 0.0 | 0.0 |
| 5 | 1075269 | 1311441 | 5000 | 5000 | 5000.0 | 36 months | 7.90% | 156.46 | A | A4 | Veolia Transportaton | 3 years | RENT | 36000.0 | Source Verified | Dec-11 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1075269 | wedding | My wedding loan I promise to pay back | 852xx | AZ | 11.20 | 0 | Nov-04 | 3 | 9 | 0 | 7963 | 28.30% | 12 | f | 0.00 | 0.00 | 5632.210000 | 5632.21 | 5000.00 | 632.21 | 0.00 | 0.00 | 0.00 | Jan-15 | 161.03 | Jan-16 | 0.0 | 1 | INDIVIDUAL | 0 | 0.0 | 0 | 0.0 | 0.0 |
| 6 | 1069639 | 1304742 | 7000 | 7000 | 7000.0 | 60 months | 15.96% | 170.08 | C | C5 | Southern Star Photography | 8 years | RENT | 47004.0 | Not Verified | Dec-11 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1069639 | debt_consolidation | Loan | 280xx | NC | 23.51 | 0 | Jul-05 | 1 | 7 | 0 | 17726 | 85.60% | 11 | f | 0.00 | 0.00 | 10110.840000 | 10110.84 | 6985.61 | 3125.23 | 0.00 | 0.00 | 0.00 | May-16 | 1313.76 | May-16 | 0.0 | 1 | INDIVIDUAL | 0 | 0.0 | 0 | 0.0 | 0.0 |
| 7 | 1072053 | 1288686 | 3000 | 3000 | 3000.0 | 36 months | 18.64% | 109.43 | E | E1 | MKC Accounting | 9 years | RENT | 48000.0 | Source Verified | Dec-11 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1072053 | car | Car Downpayment | 900xx | CA | 5.35 | 0 | Jan-07 | 2 | 4 | 0 | 8221 | 87.50% | 4 | f | 0.00 | 0.00 | 3939.135294 | 3939.14 | 3000.00 | 939.14 | 0.00 | 0.00 | 0.00 | Jan-15 | 111.34 | Dec-14 | 0.0 | 1 | INDIVIDUAL | 0 | 0.0 | 0 | 0.0 | 0.0 |
| 8 | 1071795 | 1306957 | 5600 | 5600 | 5600.0 | 60 months | 21.28% | 152.39 | F | F2 | NaN | 4 years | OWN | 40000.0 | Source Verified | Dec-11 | Charged Off | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1071795 | small_business | Expand Business & Buy Debt Portfolio | 958xx | CA | 5.55 | 0 | Apr-04 | 2 | 11 | 0 | 5210 | 32.60% | 13 | f | 0.00 | 0.00 | 646.020000 | 646.02 | 162.02 | 294.94 | 0.00 | 189.06 | 2.09 | Apr-12 | 152.39 | Aug-12 | 0.0 | 1 | INDIVIDUAL | 0 | 0.0 | 0 | 0.0 | 0.0 |
| 9 | 1071570 | 1306721 | 5375 | 5375 | 5350.0 | 60 months | 12.69% | 121.45 | B | B5 | Starbucks | < 1 year | RENT | 15000.0 | Verified | Dec-11 | Charged Off | n | https://lendingclub.com/browse/loanDetail.action?loan_id=1071570 | other | Building my credit history. | 774xx | TX | 18.08 | 0 | Sep-04 | 0 | 2 | 0 | 9279 | 36.50% | 3 | f | 0.00 | 0.00 | 1476.190000 | 1469.34 | 673.48 | 533.42 | 0.00 | 269.29 | 2.52 | Nov-12 | 121.45 | Mar-13 | 0.0 | 1 | INDIVIDUAL | 0 | 0.0 | 0 | 0.0 | 0.0 |
Last rows
| id | member_id | loan_amnt | funded_amnt | funded_amnt_inv | term | int_rate | installment | grade | sub_grade | emp_title | emp_length | home_ownership | annual_inc | verification_status | issue_d | loan_status | pymnt_plan | url | purpose | title | zip_code | addr_state | dti | delinq_2yrs | earliest_cr_line | inq_last_6mths | open_acc | pub_rec | revol_bal | revol_util | total_acc | initial_list_status | out_prncp | out_prncp_inv | total_pymnt | total_pymnt_inv | total_rec_prncp | total_rec_int | total_rec_late_fee | recoveries | collection_recovery_fee | last_pymnt_d | last_pymnt_amnt | last_credit_pull_d | collections_12_mths_ex_med | policy_code | application_type | acc_now_delinq | chargeoff_within_12_mths | delinq_amnt | pub_rec_bankruptcies | tax_liens | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39707 | 92666 | 92661 | 5000 | 5000 | 525.0 | 36 months | 9.33% | 159.77 | B | B3 | Stark and Roth Inc | 2 years | MORTGAGE | 180000.0 | Not Verified | Jul-07 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=92666 | home_improvement | home improvment loan | 530xx | WI | 11.93 | 0 | Feb-95 | 1 | 16 | 0 | 60568 | 39.20% | 38 | f | 0.0 | 0.0 | 5751.530533 | 603.91 | 5000.0 | 751.53 | 0.0 | 0.0 | 0.0 | Jul-10 | 161.55 | Jun-07 | NaN | 1 | INDIVIDUAL | 0 | NaN | 0 | NaN | NaN |
| 39708 | 92552 | 92542 | 5000 | 5000 | 375.0 | 36 months | 9.96% | 161.25 | B | B5 | Millenium Group | 4 years | MORTGAGE | 48000.0 | Not Verified | Jul-07 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=92552 | debt_consolidation | Tito5000 | 333xx | FL | 8.03 | 0 | Aug-95 | 1 | 6 | 0 | 28329 | 48.60% | 6 | f | 0.0 | 0.0 | 5804.732505 | 435.36 | 5000.0 | 804.73 | 0.0 | 0.0 | 0.0 | Jul-10 | 162.07 | Jun-10 | NaN | 1 | INDIVIDUAL | 0 | NaN | 0 | NaN | NaN |
| 39709 | 92533 | 92529 | 5000 | 5000 | 675.0 | 36 months | 11.22% | 164.23 | C | C4 | Self-Employeed | < 1 year | OWN | 80000.0 | Not Verified | Jul-07 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=92533 | credit_card | P's Family Credit Loan | 537xx | WI | 1.21 | 0 | Jul-96 | 3 | 15 | 1 | 27185 | 16.10% | 29 | f | 0.0 | 0.0 | 5912.052998 | 798.13 | 5000.0 | 912.05 | 0.0 | 0.0 | 0.0 | Jul-10 | 165.17 | Jun-07 | NaN | 1 | INDIVIDUAL | 0 | NaN | 0 | NaN | NaN |
| 39710 | 92507 | 92502 | 5000 | 5000 | 250.0 | 36 months | 7.43% | 155.38 | A | A2 | Rush Univ Med Grp | 1 year | OWN | 85000.0 | Not Verified | Jul-07 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=92507 | credit_card | My Credit Card Loan | 537xx | WI | 0.31 | 0 | Oct-97 | 0 | 7 | 0 | 216 | 0.60% | 19 | f | 0.0 | 0.0 | 5593.626092 | 279.68 | 5000.0 | 593.63 | 0.0 | 0.0 | 0.0 | Jul-10 | 156.29 | Jun-07 | NaN | 1 | INDIVIDUAL | 0 | NaN | 0 | NaN | NaN |
| 39711 | 92402 | 92390 | 5000 | 5000 | 700.0 | 36 months | 8.70% | 158.30 | B | B1 | A. F. Wolfers, Inc. | 5 years | MORTGAGE | 75000.0 | Not Verified | Jul-07 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=92402 | credit_card | Reduce Credit Card Debt | 804xx | CO | 15.55 | 0 | May-94 | 0 | 10 | 0 | 66033 | 23% | 29 | f | 0.0 | 0.0 | 5698.603286 | 797.80 | 5000.0 | 698.60 | 0.0 | 0.0 | 0.0 | Jul-10 | 159.83 | Nov-14 | NaN | 1 | INDIVIDUAL | 0 | NaN | 0 | NaN | NaN |
| 39712 | 92187 | 92174 | 2500 | 2500 | 1075.0 | 36 months | 8.07% | 78.42 | A | A4 | FiSite Research | 4 years | MORTGAGE | 110000.0 | Not Verified | Jul-07 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=92187 | home_improvement | Home Improvement | 802xx | CO | 11.33 | 0 | Nov-90 | 0 | 13 | 0 | 7274 | 13.10% | 40 | f | 0.0 | 0.0 | 2822.969293 | 1213.88 | 2500.0 | 322.97 | 0.0 | 0.0 | 0.0 | Jul-10 | 80.90 | Jun-10 | NaN | 1 | INDIVIDUAL | 0 | NaN | 0 | NaN | NaN |
| 39713 | 90665 | 90607 | 8500 | 8500 | 875.0 | 36 months | 10.28% | 275.38 | C | C1 | Squarewave Solutions, Ltd. | 3 years | RENT | 18000.0 | Not Verified | Jul-07 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=90665 | credit_card | Retiring credit card debt | 274xx | NC | 6.40 | 1 | Dec-86 | 1 | 6 | 0 | 8847 | 26.90% | 9 | f | 0.0 | 0.0 | 9913.491822 | 1020.51 | 8500.0 | 1413.49 | 0.0 | 0.0 | 0.0 | Jul-10 | 281.94 | Jul-10 | NaN | 1 | INDIVIDUAL | 0 | NaN | 0 | NaN | NaN |
| 39714 | 90395 | 90390 | 5000 | 5000 | 1325.0 | 36 months | 8.07% | 156.84 | A | A4 | NaN | < 1 year | MORTGAGE | 100000.0 | Not Verified | Jul-07 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=90395 | debt_consolidation | MBA Loan Consolidation | 017xx | MA | 2.30 | 0 | Oct-98 | 0 | 11 | 0 | 9698 | 19.40% | 20 | f | 0.0 | 0.0 | 5272.161128 | 1397.12 | 5000.0 | 272.16 | 0.0 | 0.0 | 0.0 | Apr-08 | 0.00 | Jun-07 | NaN | 1 | INDIVIDUAL | 0 | NaN | 0 | NaN | NaN |
| 39715 | 90376 | 89243 | 5000 | 5000 | 650.0 | 36 months | 7.43% | 155.38 | A | A2 | NaN | < 1 year | MORTGAGE | 200000.0 | Not Verified | Jul-07 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=90376 | other | JAL Loan | 208xx | MD | 3.72 | 0 | Nov-88 | 0 | 17 | 0 | 85607 | 0.70% | 26 | f | 0.0 | 0.0 | 5174.198551 | 672.66 | 5000.0 | 174.20 | 0.0 | 0.0 | 0.0 | Jan-08 | 0.00 | Jun-07 | NaN | 1 | INDIVIDUAL | 0 | NaN | 0 | NaN | NaN |
| 39716 | 87023 | 86999 | 7500 | 7500 | 800.0 | 36 months | 13.75% | 255.43 | E | E2 | Evergreen Center | < 1 year | OWN | 22000.0 | Not Verified | Jun-07 | Fully Paid | n | https://lendingclub.com/browse/loanDetail.action?loan_id=87023 | debt_consolidation | Consolidation Loan | 027xx | MA | 14.29 | 1 | Oct-03 | 0 | 7 | 0 | 4175 | 51.50% | 8 | f | 0.0 | 0.0 | 9195.263334 | 980.83 | 7500.0 | 1695.26 | 0.0 | 0.0 | 0.0 | Jun-10 | 256.59 | Jun-10 | NaN | 1 | INDIVIDUAL | 0 | NaN | 0 | NaN | NaN |